﻿<RecordOperationSpec 
	xmlns="bb_appfx_recordoperation"
	xmlns:c="bb_appfx_commontypes" 
	ID="f94ddf5a-a89c-4add-9cb7-cc9ceaa9fe20" 
	Name="TDSM Org Threshold Delete" 
	Description="Deletes a threshold entry for an organization, used by the TDSM datalist"
	Author="Blackbaud Professional Services"
	OperationType="Delete"
	RecordType="Organizational Hierarchy TDSM Threshold"
	c:SecurityUIFolder="TDSM Datalist"
	>

	<SPRecord>
		<SPOperationImplementation SPName="USR_USP_TDSM_ORG_THRESHOLD_DELETE">
			<c:CreateProcedureSQL>
				<![CDATA[
create procedure dbo.USR_USP_TDSM_ORG_THRESHOLD_DELETE(@ID uniqueidentifier,@CHANGEAGENTID uniqueidentifier)
as
begin
  delete USR_BUSINESSUNITCODE where id = @id;
  return 0;
end
]]>
			</c:CreateProcedureSQL>
		</SPOperationImplementation>
	</SPRecord>

	<Prompt>
		<StandardPrompt Text="Really delete this threshold entry?"/>
	</Prompt>
</RecordOperationSpec>